BusinessUnitGroupSchedule

Entity Definition

Logical Name : BusinessUnitGroupSchedule
Physical Name : CO_BSN_GP_SCHDL

An identified, named association between a CalendarPeriod and a BusinessUnitGroup that designates a predetermined period of time. Typically this is used to designate store hours, receiving hours, and other time intervals that have business activity for a business unit group associated with them. The ASSUMPTION is that a named BusinessUnitGroupSchedule will reference a DAY CalendarPeriod as part of defining a schedule for the purposes of defining a schedule. Retailers should consider establishing OPERATING CALENDARs for schedule making purposes. Note that this can be used for individual store schedule because the business unit group at the leaf level has a one to one correspondence with an individual business unit (aka store).

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
BusinessUnitGroupScheduleID (PK)	Token ID for a BusinessUnitGroupSchedule entity type instance.	ID_BSN_UN_GP_SCHDL	Identity	integer
CalendarID (FK)	A unique system assigned identifier for the Calendar.	ID_CLD	Identity	integer	CalendarPeriod(CA_CLD_PRD)
CalendarLevelID (FK)	A unique system assigned identifier for the CalendarLevel.	ID_CLD_LV	Identity	integer	CalendarPeriod(CA_CLD_PRD)
CalendarPeriodID (FK)	A unique system assigned identifier for this CalendarPeriod	ID_CLD_PRD	Identity	integer	CalendarPeriod(CA_CLD_PRD)
BusinessUnitScheduleTypeCode (FK)	A shorthand name for a type of BusinessUnitScheduleTypeCode. The value list for this attribute will be defined by each retailer. Sample values include: SELLING_HRS RECVG_HRS INVTY_HRS	CD_BSN_UN_SCHDL_TYP	Code	varchar(20)	BusinessUnitGroupScheduleType(CO_BSN_GP_SCHDL_TYP)
BusinessUnitGroupID (FK)	A unique system assigned identifier for a group of BusinessUnits.	ID_BSNGP	Identity	integer	BusinessUnitGroup(CO_BSNGP)

Relationships

Parent Entity	Verb Phrase	Child Entity
CalendarPeriod	designated period of	BusinessUnitGroupSchedule
BusinessUnitGroupScheduleType	classifies	BusinessUnitGroupSchedule
BusinessUnitGroup	is scheduled by	BusinessUnitGroupSchedule

Logical Views containing BusinessUnitGroupSchedule

Logical View
Logical 06100 - Calendar View